![]() | ![]() | ![]() | ![]() | ![]() |
The SAS® Merchandise Intelligence baseline_sas_validate_schema.sas job might generate the following error in the baseline_sas_validate_schema.sas log file. This job is run only during migration from a prior release of SAS® Revenue Optimization or SAS® Size Optimization to release 5.2.
ERROR: BY variables are not properly sorted on data set WORK.COMP_CONSTRAINTS. memname=VENDOR column_name=VENDOR_SK constraint_name=PRIM_KEY constraint_type=PRIMARY FIRST.memname=1 LAST.memname=1 COLUMN_NAMES=VEHICLE_SUPPORT_MAP_SK _ERROR_=1 _N_=218 NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 219 observations read from the data set WORK.COMP_CONSTRAINTS. WHERE constraint_type='PRIMARY'; WARNING: The data set WORK.COMP_PK_COLUMNS may be incomplete. When this step was stopped there were 104 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds ERROR: BY variables are not properly sorted on data set WORK.COMP_CONSTRAINTS. memname=VEHICLE_SUPPORT_MAP_PREV column_name=SUPPORT_NM constraint_name=_NM0002_ constraint_type=NOT NULL FIRST.memname=1 LAST.memname=0 _ERROR_=1 _N_=23 NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 24 observations read from the data set WORK.COMP_CONSTRAINTS. WHERE constraint_type='NOT NULL'; WARNING: The data set WORK.COMP_NOT_NULL_CONS may be incomplete. When this step was stopped there were 22 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds
This error occurs when data in the DICTIONARY.CONSTRAINT_COLUMN_USAGE table or the DICTIONARY.TABLE_CONSTRAINTS table is not in the expected sort order.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Product Family | Product | System | Product Release | SAS Release | ||
Reported | Fixed* | Reported | Fixed* | |||
SAS System | SAS Promotion Optimization | Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
SAS System | SAS Retail Forecasting | Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
SAS System | SAS Markdown Optimization | Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M2 |
Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M2 | ||
SAS System | SAS Regular Price Optimization | Linux for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 |
Microsoft® Windows® for x64 | 5.2_M4 | 5.4 | 9.3 TS1M2 | 9.4 TS1M3 | ||
SAS System | SAS Pack Optimization | Microsoft® Windows® for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M2 |
64-bit Enabled AIX | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M2 | ||
Linux for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M2 | ||
SAS System | SAS Size Profiling | Microsoft® Windows® for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M2 |
64-bit Enabled AIX | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M2 | ||
Linux for x64 | 3.2_M4 | 3.4 | 9.3 TS1M2 | 9.4 TS1M2 |